package com.weishenai.customerassistant.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.weishenai.customerassistant.entity.Electrical;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Set;

public interface ElectricalMapper extends BaseMapper<Electrical> {
    @Select("SELECT * from electrical where electrical_transformer_name like '${name}%'")
    List<Electrical> selectByName(String name);
    @Select("select electrical_transformer_name from electrical  GROUP BY electrical_transformer_name")
    Set<String> selectName();
}
